CREATE TABLE [dbo].[JOL_Link]
(
[JOL_Link_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Link_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_Website] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_AddTime] [datetime] NULL,
[JOL_Link_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_UpdateTime] [datetime] NULL,
[JOL_Link_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Link_ImageUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Link] ADD CONSTRAINT [PK__JOL_Link__25C68D63] PRIMARY KEY CLUSTERED  ([JOL_Link_No]) ON [PRIMARY]
GO
